KS_MFG_ITEMS

1

Item ID

string

25

Y

PK constraint

2

Short Description

string

100

3

Brand

string

75

The manufacturers named brand name. This is a display/filter field only

4

Lead Time

integer

4

Specify lead time in days

5

Lead Time Units

string

1

'D' = Days

6

Unit Weight

float

Weight is used for freight estimation during checkout (optional)

7

Unit of Measure

string

10

This is the normal stocking unit of measure for the item. It is assumed that inventory and ATP quantity is based on this UOM

8

Model Flag

string

1

Y

('Y','N')

If this is a Model which can be configured, set to 'Y". To configuration on-line requires webConfigurator add-on module.

9

Serial Control Flag

string

1

Y

('Y','N')

If item is serial controlled, set to 'Y'. Used by webServiceCenter application for warranty and service requests.

10

Unit Cost

money

11

Units per Package

integer

4

Y

When the inventory units are represented in single units but physically packaged in multiples of n. Used for display and to determine broken pack charge if applicable.

12

Packaging Text

string

100

When the inventory units reflect a packaged quantity. For example, 1 unit in inventory is a 5-pack. This is a string which can be display purposes only.

13

UPC

string

14

14

Category

string

30

This is an internal category code for an item. A lookup is made based on this field (xref) used to find the foreign key row

15

Tax Group Code

string

50

'Y' || 'N'

Code that can be used by sales tax software API such as Avalara to calculate accurate sales tax on items

16

Special Charge ID

string

30

Data field exported is looked up against the special_charge.charge_xref_id column to find the charge_no PK value.

17

Charge Amount

money

This is the amount that will be added to the item price if the item is purchased (can be positive or negative)

18

Price UOM

string

10

Y

This is the normal pricing unit of measure for the item. It is assumed that all price lists and discounts are based on this UOM unless otherwise specified.

19

Alternate UOM

string

10

Alternate UOM which this item can be priced or reflected in inventory

20

Stock to Alt UOM Factor

numeric

10,2

If an alternate UOM exists, this is the factor which will be applied to convert the stock UOM to the alternate UOM

21

Web Available

string

1

Y

'Y' || 'N'

If an alternate UOM exists, this flag indicates if it can be sold in this UOM on the web.

22

Restraint Code

string

20

Restraint codes can be used to control messaging displayed to users for the product as well as restrict shipping methods during checkout. The actual messaging and restrictions for each code is defined online in KommerceServer. Any code sent via this export will be automatically created in KommerceServer.

23

Matrix Group Values

string

Max

Use "&" to delimit between pairs and use_ "=" to match a Group to a Value.
If a Group has multiple values
then use "," separator between values.

This is a JSON formatted string of named value pairs which will be parsed and optimized exclusively for the purposes of price matrix selection. Any associated group value that may participate in a price matrix should be included for the item. For example, if you provide price matrix discounts based on a specific product price group, specific product, or a specific vendor the string may look like: "PRODUCT_GROUP":["ABC","XYZ"],"ITEM_ID":"123","VENDOR":"10998" Note: GROUP names should be consistent between items but the group VALUES may obviously vary between items

24

Minimum Break Quantity

integer

4

This is the minimum quantity or amount that must be purchased on a given order to qualify for the price adjustment. This field is only needed if there are price adjustments that define discount levels for a group of items but use the specific breaks defined for each related item. See KS_PRICE_ADJS documentation for "Use Item Quantity Breaks"

25

Maximum Break Quantity

integer

4

The field works in conjunction with the Minimum Break quantity field and represents the maximum quantity or amount that can be purchased to receive this price before moving to the next volume price level. Typically, the last volume range max value is set to an extreme level that is not typically purchased (e.g. 999,999). The price calculation does not assume the last range is infinite so if this is not done the customer may revert to a higher price. This field is only needed if there are price adjustments that define discount levels for a group of items but use the specific breaks defined for each related item. See KS_PRICE_ADJS documentation for "Use Item Quantity Breaks"

26

Sum and Reprice Flag

string

1

Y

"Y" || "N"

A Y indicates that this item is eligible for sum & reprice discounts. A Sum & Reprice Group must also be specified

27

Sum and Reprice Group

string

50

This is a group name for purposes of aggregating quantity or amounts in order to determine sum & reprice discounts. All cart items sharing the same group name will be aggregated together. If an item can be aggregated but is not a product that is specifically discounted, a group can be supplied but the sum & reprice flag is set to 'N'.

28

Length

integer

Indicates the length of the item.

29

Width

integer

Indicates the width of the item.

30

Depth

integer

Indicates the depth of the item.

31

Dim Units

integer

The unit of measure for the dimensions (e.g. ft, In, mm, cm,etc.)

32

Freight Class Code

string

Indicates the Freight Class of the item for shipping purposes.

33

Minimum Order Qty

integer

Indicates a minimum order quantity for the item enforced by the Store.

34

Order Multiple Qty

integer

Indicates the order multiple quantity for the item enforced by the Store. For example, given an order multiple of 10, the store will only allow to purchase 10,20,30, etc.

35

Taxable Flag

string

"Y" || "N"

A Y indicates that the item is taxable.

36

Item Class Code

string

Indicates the internal code that has been assigned to the item class. This can be used to automatically associate new items into the item class hierarchy defined for the store.

37

Access Group Codes

Specifies the Access Group Code for the item. . If present then the store will not allow this item to be seen or purchased except by those customers that are associated to the same access group.

38

Price Mode

'STANDARD','COMPONENT','KIT'

Determines the pricing strategy. STANDARD only considers this item alone whereas KIT and COMPONENT pricing strategies will consider component items sent as part of the KS_BOMS API. KIT pricing will rollup pricing for all components without discoutning but will then discount the the KIT. COMP pricing strategy will apply all discounts to each component and then rollup to the end item without any frther discounts applied.